/*
 * $Id: CurriculumHourDao.java 1141 2011-07-08 02:04:27Z jyang $
 * 
 * Copyright (c) 2001-2008 Accentrix Company Limited. All Rights Reserved.
 * 
 * Accentrix Company Limited. ("Accentrix") retains copyright on all text, source
 * and binary code contained in this software and documentation. Accentrix grants
 * Licensee a limited license to use this software, provided that this copyright
 * notice and license appear on all copies of the software. The software source
 * code is provided for reference purposes only and may not be copied, modified 
 * or distributed.
 * 
 * THIS SOFTWARE AND DOCUMENTATION ARE PROVIDED "AS IS," WITHOUT ANY WARRANTY OF
 * ANY KIND UNLESS A SEPARATE WARRANTIES IS PURCHASED FROM ACCENTRIX AND REMAINS
 * VALID.  ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES,
 * INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
 * PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. ACCENTRIX SHALL NOT BE LIABLE
 * FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING OR MODIFYING THE
 * SOFTWARE OR ITS DERIVATIVES.
 * 
 * IN NO EVENT WILL ACCENTRIX BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR
 * FOR DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
 * HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE
 * USE OF OR INABILITY TO USE SOFTWARE, EVEN IF ACCENTRIX HAS BEEN ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGES.
 */
package com.lightsaber.trade.cloth.dao.programme;

import java.util.List;

import org.hibernate.Query;
import org.springframework.stereotype.Component;

import com.lightsaber.trade.core.dao.BaseDao;
import com.lightsaber.trade.cloth.entity.programme.CurriculumHour;

@Component
public class CurriculumHourDao extends BaseDao<CurriculumHour, String> {

    public void deleteByProgrammeIdAndYear(final String programmeId, final Integer year) {
        String hql = "delete from CurriculumHour as ch "
                + "where ch.programme.id=:programmeId and ch.year=:year";

        Query q = this.createQuery(hql);
        q.setParameter("programmeId", programmeId);
        q.setParameter("year", year);

        q.executeUpdate();

    }

    public List<CurriculumHour> findByProgrammeId(final String programmeId) {
        eq("programme.id", programmeId);

        return list();
    }

    public long countByProgrammeId(final String programmeId) {
        eq("programme.id", programmeId);

        return count();
    }

    public List<CurriculumHour> findByProgrammeIdAndYear(final String programmeId,
            final Integer year) {
        eq("programme.id", programmeId);
        eq("year", year);
        return list();
    }
}
